/*
* Distributable under LGPL v3 license.
* See terms of license at https://github.com/Yunfeng/schotel/blob/master/LICENSE
*/
package cn.buk.hotel.dao;

import cn.buk.hotel.entity.City;
import org.apache.log4j.Logger;
import org.springframework.transaction.annotation.Transactional;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceException;
import java.util.List;


/**
 * User: william
 * Date: 14-9-29
 * Time: 下午11:27
 */
public class CityDaoImpl extends AbstractDao implements CityDao {

    private static Logger logger = Logger.getLogger(CityDaoImpl.class);

    @Override
    @Transactional
    public int create(City city) {
        int retStatus = 0;
        EntityManager em = getEm();
        try {
            em.persist(city);
            retStatus = 1;
        } catch (Exception ex) {
            retStatus = -1;
            logger.error(ex.getMessage());
        }
        return retStatus;
    }

    @Override
    public City getCityByOpenApiId(int openApiId) {
        List<City> cities = getEm().createQuery("select o from City o where o.openApiId = :openApiId")
                .setParameter("openApiId", openApiId)
                .getResultList();
        if (cities == null || cities.size() == 0) return null;

        return cities.get(0);
    }

    @Override
    public City getCityByCode(String cityCode) {
        List<City> cities = getEm().createQuery("select o from City o where o.cityCode = :cityCode")
                .setParameter("cityCode", cityCode)
                .getResultList();
        if (cities == null || cities.size() == 0) return null;

        return cities.get(0);
    }


    @Override
    public List<City> getAllCity() {
        List<City> cities = null;
        try {
            cities = getEm().createQuery("select o from City o order by o.openApiId")
                    .getResultList();
        } catch (PersistenceException e) {
            logger.error(e.getMessage());
        }
        return cities;
    }

    @Override
    public List<City> getCityHotelGreaterThan100() {
        List<City> cities = null;
        try {
            //select o from City o where o.openApiId in (select h.cityId from HotelInfo h group by h.cityId having count(h) > 100)
            cities = getEm().createQuery("select o from City o where o.openApiId in (select h.cityId from HotelInfo h group by h.cityId having count(h) > 100)")
                    .getResultList();
        } catch (PersistenceException e) {
            logger.error(e.getMessage());
        }
        return cities;
    }
}